﻿IF EXISTS (SELECT * from sys.procedures p left join sys.schemas s on p.schema_id = s.schema_id where p.name='category_select_all' and s.name='Budget')
DROP PROCEDURE [Budget].category_select_all
GO
CREATE PROCEDURE [Budget].category_select_all 
AS
BEGIN
SELECT 	
	[Categories].[id_category] AS [PK],
	[Categories].[name] AS [Name],
	[Categories].[description] AS [Description],
	[Categories].[color] AS [Color]
FROM 
	[Categories] 
END